Period On Period

The Period on Period functions use the lag function to return the given member and the member that is one position before the given member, in the same level. For instance, if a Quarter on Quarter calculation is selected, and the given date is Q2 2010, then both Q2 2010 and Q2 2009 are returned.

Period On Period functions generate the following elements:

  • A parameter, which is used to inject a date into the query at runtime.
  • Percentage difference custom calculations, which return a custom member when added to the query, showing the percentage difference between the two time periods.
  • Custom lists, which return a list of dates when added to the query (the given date selected from the parameter, and the parallel period).

Examples